Welcome to python!

9、合并同类项目

import pandas as pd, xlwings as xw

path=r"E:\韦瑞奎\E1其他工作\财务部\舒小红/合并同类项目.xlsx"

df=pd.read_excel(path,"合并同类项目")

print(df)

# 将日期字符串转换为datetime

# df['Date'] = pd.to_datetime(df['Payment Date'])

df=df.fillna("")

df["合并项目"]=df['INVOICE NO']+df['Payment Date']

dfs=df.drop_duplicates(subset="合并项目")

# 使用groupby按ID合并日期

df_merged = dfs.groupby('INVOICE NO')['Payment Date'].agg(lambda x: ', '.join(x.astype(str))).reset_index()

print(df_merged)

wb = xw.Book(path)

sheet0 = wb.sheets['合并同类项']

sheet0.range('A1').value = df_merged

返回值：